package com.neusoft.elmboot.mapper;

import java.math.BigDecimal;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * @author chj
 * @date 2024年10月24日
 */
@Mapper
public interface EditablePropertiesMapper {

	@Update("update editableproperties set REFILLBONUS=#{num} where id = 1")
	public int updateREFILLBONUS(BigDecimal num);

	@Update("update editableproperties set SURCHARGE=#{num} where id = 1")
	public int updateSURCHARGE(BigDecimal num);

	@Update("update editableproperties set OVERDRAFT_MAX_AMOUNT=#{num} where id = 1")
	public int updateOVERDRAFT_MAX_AMOUNT(BigDecimal num);

	@Select("select REFILLBONUS from editableproperties where id = 1")
	public BigDecimal getREFILLBONUS();

	@Select("select SURCHARGE from editableproperties where id = 1")
	public BigDecimal getSURCHARGE();

	@Select("select OVERDRAFT_MAX_AMOUNT from editableproperties where id = 1")
	public BigDecimal getOVERDRAFT_MAX_AMOUNT();

	@Select("select VALID_TIME from editableproperties where id = 1")
	public Long getVALID_TIME();

	@Select("select RATIO_BUY from editableproperties where id = 1")
	public BigDecimal getRATIO_BUY();

	@Select("select RATIO_GET_CHANNEL_1 from editableproperties where id = 1")
	public BigDecimal getRATIO_GET_CHANNEL_1();

}
